Release 10.1A: OpenEdge Data Management:
SQL Development

Advantages of stored procedures

Stored procedures and triggers expand the flexibility and performance of applications that access the OpenEdge SQL environment. They provide a mechanism for storing a collection of SQL statements and Java program constructs that enforce business rules and perform administrative tasks in a database.

Stored procedures and triggers enhance applications by:

Enabling a client application to perform a procedure with a single request instead of multiple requests for each SQL statement.
Executing faster than a corresponding SQL script.
Implementing elaborate algorithms to enforce complex business rules. The details of the procedure implementation can change without requiring changes in an application that calls the procedure.